﻿CREATE TABLE [acms].[ControlTypes] (
    [Id]                      INT            IDENTITY (1, 1) NOT NULL,
    [SiteId]                  INT            NULL,
    [Name]                    VARCHAR (50)   NULL,
    [AdminControlType]        VARCHAR (255)  NULL,
    [AdminEditControlType]    VARCHAR (255)  NULL,
    [AdminDisplayControlType] VARCHAR (255)  NULL,
    [FrontEndControlType]     VARCHAR (255)  NULL,
    [Notes]                   VARCHAR (1000) NULL,
    [Custom]                  BIT            NULL,
    [Deleted]                 BIT            NULL,
    [VersionId]               TIMESTAMP      NOT NULL
);

